Ì € i 2
main
[applicant]
$(JA)JA.Y[jay]
Field Name Len Dat Typ J DPM Offset/Local/VAL
applicant 42 URN L jay
cd.screen 15 FREE L MIS.SCREEN VAL=@PP.JOB.opening.cds[@op.job]
employee 42 URN L PP.PER $(JA)JA.Y[jay]|1
name 26 FREE L VAL=IF{@PP.APPL.employee @PP.APPL.employee's.name;@PP.
VAL=APPL.per.name}
number 8 PINT R $(JA)JA.Y[jay]|0
per.address1 30 FREE L $(JA)JA.Y[jay]JY["0"]|0
per.address2 30 FREE L $(JA)JA.Y[jay]JY["0"]|1
per.city 18 FREE L $(JA)JA.Y[jay]JY["0"]|2
per.date.of.birth 10 BDATE L $(JA)JA.Y[jay]JY|11
per.disability 1 YN L $(JA)JA.Y[jay]JY["M1"]|0
per.eeoc 18 CHOICE L $(JA)JA.Y[jay]JY|13
per.email.addr 40 FREE L $(JA)JA.Y[jay]JY["M1"]|9
per.emergency.phone 18 PHONE L $(JA)JA.Y[jay]JY|10
per.home.phone 18 PHONE L $(JA)JA.Y[jay]JY|9
per.name 26 NAME L $(JA)JA.Y[jay]JY|2
per.other.country 10 FREE L $(JA)JA.Y[jay]JY["0"]|6
per.other.country.choice 6 CHOICE L $(JA)JA.Y[jay]JY["0"]|5
per.pop.grp 8 FREE L PP.POPUL $(JA)JA.Y[jay]JY["M1"]|1
per.postal.code 10 FREE L $(JA)JA.Y[jay]JY["0"]|4
per.sex 1 CHOICE L $(JA)JA.Y[jay]JY|12
per.si.number 12 FREE L $(JA)JA.Y[jay]JY|1
per.sort.name 26 NAME L $(JA)JA.Y[jay]JY|3
per.ss.number 12 FREE L $(JA)JA.Y[jay]JY|1
per.state 2 FREE L $(JA)JA.Y[jay]JY["0"]|3
per.t4.country 10 FREE L $(JA)JA.Y[jay]JY["6"]|3
per.t4.country.choice 5 CHOICE L $(JA)JA.Y[jay]JY["6"]|2
picture.aspect 3 FREE L $(JA)JA.Y[jay]|4
picture.date 8 DATE L $(JA)JA.Y[jay]|3
picture.folder 4 FREE L $(JA)JA.Y[jay]|2
print.cd.screen 0 FREE L VAL=IF{@cd.screen %MIS.SCREEN.print(@cd.screen,^@custo
VAL=mer.def.fields,"",3),""}
print.cd.screen.verbatim 0 FREE L VAL=IF{@cd.screen %MIS.SCREEN.print(@cd.screen,^@custo
VAL=mer.def.fields,1,0),""}
Ì € i 2
comments
[applicant, comment.line.number]
$(JA)JA.Y[jay]C[jayC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
comment.line.number 4 PINT R jayC
comment.line 92 TEXT L $(JA)JA.Y[jay]C[jayC]
Ì € i 2
customer.def.queries
[applicant, cd.query]
$(JA)JA.Y[jay]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cd.query 10 FREE L MIS.QUERY ggv
cd.response 75 QRY.RESP L $(JA)JA.Y[jay]CD[ggv]|0
cd.yn.comment 75 FREE L $(JA)JA.Y[jay]CD[ggv]|5
Ì € i 2
customer.def.mult.queries
[applicant,cd.query, cdm.seq.no]
$(JA)JA.Y[jay]CD[ggv]M[ggvN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cdm.seq.no 3 PINT R ggvN
cdm.response 75 QRY.RESP L $(JA)JA.Y[jay]CD[ggv]M[ggvN]|0
Ì € i 2
education
[applicant, ed.q]
$(JA)JA.Y[jay]E[jayE]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ed.q 2 INT R jayE
ed.degree 8 FREE L PP.DEGREE $(JA)JA.Y[jay]E[jayE]|4
ed.degree.yr 4 YEAR L $(JA)JA.Y[jay]E[jayE]|5
ed.from.yr 4 YEAR L $(JA)JA.Y[jay]E[jayE]|2
ed.institution 40 FREE L $(JA)JA.Y[jay]E[jayE]|0
ed.major 8 FREE L PP.MAJOR $(JA)JA.Y[jay]E[jayE]|1
ed.thru.yr 4 YEAR L $(JA)JA.Y[jay]E[jayE]|3
Ì € i 2
openings
[applicant, op.q]
$(JA)JA.Y[jay]P[jayP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
op.q 2 PINT R jayP
op.appl.date 8 DATE L $(JA)JA.Y[jay]P[jayP]|0
op.cds.exists 1 FREE L VAL=@PP.JOB.opening.cds[@op.job]
op.job 10 FREE L PP.JOB $(JA)JA.Y[jay]P[jayP]|8
op.opening 8 PINT R PP.OPENING $(JA)JA.Y[jay]P[jayP]|6
op.pay.desired 10 MONEY R $(JA)JA.Y[jay]P[jayP]|11
op.pay.period 5 CHOICE L $(JA)JA.Y[jay]P[jayP]|12
op.position 18 FREE L PP.POS $(JA)JA.Y[jay]P[jayP]|7
op.recruiter 10 FREE L MIS.USER $(JA)JA.Y[jay]P[jayP]|9
op.recruiter.access 1 YN L $(JA)JA.Y[jay]P[jayP]|10
op.ref.source 8 URN L PP.REF.SOURCE $(JA)JA.Y[jay]P[jayP]|5
op.ref.type 8 FREE L PP.REF.TYPE $(JA)JA.Y[jay]P[jayP]|4
op.status 8 CHOICE L $(JA)JA.Y[jay]P[jayP]|1
op.status.date 8 DATE L $(JA)JA.Y[jay]P[jayP]|2
op.status.reason 10 FREE L PP.REASON $(JA)JA.Y[jay]P[jayP]|3
Ì € i 2
interviews
[applicant,op.q, iv.q]
$(JA)JA.Y[jay]P[jayP]V[jayV]
Field Name Len Dat Typ J DPM Offset/Local/VAL
iv.q 2 PINT R jayV
iv.date 8 DATE L $(JA)JA.Y[jay]P[jayP]V[jayV]|3
iv.dept 15 FREE L MIS.GL.DEPT $(JA)JA.Y[jay]P[jayP]V[jayV]|8
iv.status 9 CHOICE L $(JA)JA.Y[jay]P[jayP]V[jayV]|0
iv.status.date 8 DATE L $(JA)JA.Y[jay]P[jayP]V[jayV]|1
iv.status.reason 10 FREE L PP.REASON $(JA)JA.Y[jay]P[jayP]V[jayV]|2
iv.time.from 4 TIME L $(JA)JA.Y[jay]P[jayP]V[jayV]|4
iv.time.thru 4 TIME L $(JA)JA.Y[jay]P[jayP]V[jayV]|5
iv.user 10 FREE L MIS.USER $(JA)JA.Y[jay]P[jayP]V[jayV]|6
iv.user.access 1 YN L $(JA)JA.Y[jay]P[jayP]V[jayV]|7
Ì € i 2
iv.comments
[applicant,op.q,iv.q, iv.comment.line.number]
$(JA)JA.Y[jay]P[jayP]V[jayV]C[jayIC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
iv.comment.line.number 4 PINT R jayIC
iv.comment.line 92 TEXT L $(JA)JA.Y[jay]P[jayP]V[jayV]C[jayIC]
Ì € i 2
op.comments
[applicant,op.q, op.comment.line.number]
$(JA)JA.Y[jay]P[jayP]C[jayOC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
op.comment.line.number 4 PINT R jayOC
op.comment.line 92 TEXT L $(JA)JA.Y[jay]P[jayP]C[jayOC]
Ì € i 2
routing
[applicant,op.q, ro.q]
$(JA)JA.Y[jay]P[jayP]R[jayR]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ro.q 2 PINT R jayR
ro.dept 15 FREE L MIS.GL.DEPT $(JA)JA.Y[jay]P[jayP]R[jayR]|7
ro.return.date 8 DATE L $(JA)JA.Y[jay]P[jayP]R[jayR]|4
ro.send.date 8 DATE L $(JA)JA.Y[jay]P[jayP]R[jayR]|3
ro.status 10 CHOICE L $(JA)JA.Y[jay]P[jayP]R[jayR]|0
ro.status.date 8 DATE L $(JA)JA.Y[jay]P[jayP]R[jayR]|1
ro.status.reason 10 FREE L PP.REASON $(JA)JA.Y[jay]P[jayP]R[jayR]|2
ro.user 10 FREE L MIS.USER $(JA)JA.Y[jay]P[jayP]R[jayR]|5
ro.user.access 1 YN L $(JA)JA.Y[jay]P[jayP]R[jayR]|6
Ì € i 2
ro.comments
[applicant,op.q,ro.q, ro.comment.line.number]
$(JA)JA.Y[jay]P[jayP]R[jayR]C[jayRC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ro.comment.line.number 4 PINT R jayRC
ro.comment.line 92 TEXT L $(JA)JA.Y[jay]P[jayP]R[jayR]C[jayRC]
Ì € i 2
per.skills
[applicant, per.skill]
$(JA)JA.Y[jay]JY["4",gqk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
per.skill 10 FREE L MIS.SKILL gqk
Ì € i 2
phone.numbers
[applicant, ph.q]
$(JA)JA.Y[jay]H[jyaH]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ph.q 2 PINT R jyaH
ph.comment 30 FREE L $(JA)JA.Y[jay]H[jyaH]|1
ph.number 18 PHONE L $(JA)JA.Y[jay]H[jyaH]|0
Ì € i 2
work.experience
[applicant, we.q]
$(JA)JA.Y[jay]W[jayW]
Field Name Len Dat Typ J DPM Offset/Local/VAL
we.q 2 INT R jayW
we.addr1 35 FREE L $(JA)JA.Y[jay]W[jayW]|1
we.addr2 35 FREE L $(JA)JA.Y[jay]W[jayW]|2
we.from.date 8 DATE L $(JA)JA.Y[jay]W[jayW]|4
we.job 10 FREE L PP.WORK $(JA)JA.Y[jay]W[jayW]|10
we.more 1 FREE L VAL=%PP.APPL.we.more(^@work.experience)
we.name 35 FREE L $(JA)JA.Y[jay]W[jayW]|0
we.phone 18 PHONE L $(JA)JA.Y[jay]W[jayW]|3
we.reason.left 10 FREE L PP.REASON $(JA)JA.Y[jay]W[jayW]|12
we.salary.final 10 MONEY R $(JA)JA.Y[jay]W[jayW]|8
we.salary.initial 10 MONEY R $(JA)JA.Y[jay]W[jayW]|7
we.salary.period 5 CHOICE L $(JA)JA.Y[jay]W[jayW]|9
we.supervisor 20 FREE L $(JA)JA.Y[jay]W[jayW]|11
we.thru.date 8 DATE L $(JA)JA.Y[jay]W[jayW]|5
we.years 2 INT R $(JA)JA.Y[jay]W[jayW]|6
Ì € i 2
we.comments
[applicant,we.q, we.comment.line.number]
$(JA)JA.Y[jay]W[jayW]C[jayWC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
we.comment.line.number 4 PINT R jayWC
we.comment.line 92 TEXT L $(JA)JA.Y[jay]W[jayW]C[jayWC]
Ì i 2
process.web.jalist
[pr.ja.seq]
/JA.PS["W",prjSQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pr.ja.seq 10 PINT R prjSQ
pr.ja.emp 1 FREE L /JA.PS["W",prjSQ]|6
pr.ja.name 26 FREE L /JA.PS["W",prjSQ]|4
pr.ja.number 12 FREE L /JA.PS["W",prjSQ]|5
pr.ja.status 10 CHOICE L /JA.PS["W",prjSQ]|3
pr.ja.submit.date 8 DATE L /JA.PS["W",prjSQ]|1
pr.ja.submit.time 4 HHMM L /JA.PS["W",prjSQ]|2
pr.ja.urn 10 URN L /JA.PS["W",prjSQ]|0
Ì i 2
web.job.appl
[wfr.urn]
*(JA)JA.WFR[wfr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfr.urn 10 URN L wfr
wfr.applicant 42 URN L PP.APPL *(JA)JA.WFR[wfr]|4
wfr.per.address1 30 FREE L *(JA)JA.WFR[wfr]JY["0"]|0
wfr.per.address2 30 FREE L *(JA)JA.WFR[wfr]JY["0"]|1
wfr.per.city 18 FREE L *(JA)JA.WFR[wfr]JY["0"]|2
wfr.per.date.of.birth 10 BDATE L *(JA)JA.WFR[wfr]JY|4
wfr.per.email.addr 40 FREE L *(JA)JA.WFR[wfr]JY|6
wfr.per.emp.number 14 FREE L *(JA)JA.WFR[wfr]JY|7
wfr.per.home.phone 18 PHONE L *(JA)JA.WFR[wfr]JY|3
wfr.per.name 26 NAME L *(JA)JA.WFR[wfr]JY|2
wfr.per.postal.code 10 FREE L *(JA)JA.WFR[wfr]JY["0"]|4
wfr.per.sex 1 CHOICE L *(JA)JA.WFR[wfr]JY|5
wfr.per.si.number 12 FREE L *(JA)JA.WFR[wfr]JY|1
wfr.per.ss.number 12 FREE L *(JA)JA.WFR[wfr]JY|1
wfr.per.state 2 FREE L *(JA)JA.WFR[wfr]JY["0"]|3
wfr.status 10 CHOICE L *(JA)JA.WFR[wfr]|1
wfr.status.time 10 PINT R *(JA)JA.WFR[wfr]|3
wfr.status.user 10 FREE L MIS.USER *(JA)JA.WFR[wfr]|2
wfr.submit.secs 10 PINT R *(JA)JA.WFR[wfr]|0
Ì € i 2
web.job.appl.comments
[wfr.urn, wfr.com.line.no]
*(JA)JA.WFR[wfr]C[wfrC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfr.com.line.no 4 PINT R wfrC
wfr.com.line 92 TEXT L *(JA)JA.WFR[wfr]C[wfrC]
Ì € i 2
web.job.appl.education
[wfr.urn, wfr.ed.q]
*(JA)JA.WFR[wfr]E[wfrE]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfr.ed.q 2 INT R wfrE
wfr.ed.degree 8 FREE L PP.DEGREE *(JA)JA.WFR[wfr]E[wfrE]|4
wfr.ed.degree.yr 4 YEAR L *(JA)JA.WFR[wfr]E[wfrE]|5
wfr.ed.from.yr 4 YEAR L *(JA)JA.WFR[wfr]E[wfrE]|2
wfr.ed.inst 40 FREE L *(JA)JA.WFR[wfr]E[wfrE]|0
wfr.ed.major 8 FREE L PP.MAJOR *(JA)JA.WFR[wfr]E[wfrE]|1
wfr.ed.thru.yr 4 YEAR L *(JA)JA.WFR[wfr]E[wfrE]|3
Ì € i 2
web.job.appl.openings
[wfr.urn, wfr.opening]
*(JA)JA.WFR[wfr]P[jaa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfr.opening 8 PINT R PP.OPENING jaa
Ì € i 2
web.job.appl.per.skills
[wfr.urn, wfr.per.skill]
*(JA)JA.WFR[wfr]4[gqk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfr.per.skill 10 FREE L MIS.SKILL gqk
Ì € i 2
web.job.appl.phone.nums
[wfr.urn, wfr.ph.q]
*(JA)JA.WFR[wfr]H[wfrP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfr.ph.q 2 PINT R wfrP
wfr.ph.comment 30 FREE L *(JA)JA.WFR[wfr]H[wfrP]|1
wfr.ph.number 18 PHONE L *(JA)JA.WFR[wfr]H[wfrP]|0
Ì € i 2
web.job.appl.work
[wfr.urn, wfr.we.q]
*(JA)JA.WFR[wfr]W[wfrW]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfr.we.q 2 INT R wfrW
wfr.we.addr1 35 FREE L *(JA)JA.WFR[wfr]W[wfrW]|1
wfr.we.addr2 35 FREE L *(JA)JA.WFR[wfr]W[wfrW]|2
wfr.we.from.date 8 DATE L *(JA)JA.WFR[wfr]W[wfrW]|4
wfr.we.job 10 FREE L PP.WORK *(JA)JA.WFR[wfr]W[wfrW]|10
wfr.we.name 35 FREE L *(JA)JA.WFR[wfr]W[wfrW]|0
wfr.we.phone 18 PHONE L *(JA)JA.WFR[wfr]W[wfrW]|3
wfr.we.reason.left 10 FREE L PP.REASON *(JA)JA.WFR[wfr]W[wfrW]|12
wfr.we.salary.final 10 MONEY R *(JA)JA.WFR[wfr]W[wfrW]|8
wfr.we.salary.initial 10 MONEY R *(JA)JA.WFR[wfr]W[wfrW]|7
wfr.we.salary.period 5 CHOICE L *(JA)JA.WFR[wfr]W[wfrW]|9
wfr.we.supervisor 20 FREE L *(JA)JA.WFR[wfr]W[wfrW]|11
wfr.we.thru.date 8 DATE L *(JA)JA.WFR[wfr]W[wfrW]|5
wfr.we.years 2 INT R *(JA)JA.WFR[wfr]W[wfrW]|6
Ì € i 2
web.job.appl.we.comments
[wfr.urn,wfr.we.q, wfr.we.com.line.no]
*(JA)JA.WFR[wfr]W[wfrW]C[wfrWC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfr.we.com.line.no 4 PINT R wfrWC
wfr.we.com.line 92 TEXT L *(JA)JA.WFR[wfr]W[wfrW]C[wfrWC]
Ì i 2
web.job.appl.queue
[wfq.date,wfq.appl.urn]
*(JA)JA.WFQ[wfqDT,wfr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfq.date 8 DATE L wfqDT
wfq.appl.urn 10 URN L wfr
wfq.time 4 HHMM L *(JA)JA.WFQ[wfqDT,wfr]|0
Index Files Subscripts/Physical Base
app.dt.letter.x [applicant,print.date,letter,printing]
?(JA)JA.YAL[jay,jllPD,jllt,jllID]
employee.x [employee] = applicant
?(JA)JA.YE[jy]
id.x [per.id,applicant]
?(JA)JA.YI[jyI,jay]
interviewer.x [iv.user,applicant,op.q,iv.q]
?(JA)JA.YV[gu,jay,jayP,jayV]
name.x [per.sort.name,applicant]
?(JA)JA.YN[jySN,jay]
number.x [applicant]
?(JA)JA.YX[jay]
opening.x [op.opening,applicant] = op.q
?(JA)JA.YA[jaa,jay]
recruiter.x [op.recruiter,applicant,op.q]
?(JA)JA.YT[gu,jay,jayP]
ref.source.x [op.ref.source,applicant,op.q]
?(JA)JA.YS[jas,jay,jayP]
ro.user.x [ro.user,applicant,op.q,ro.q]
?(JA)JA.YU[gu,jay,jayP,jayR]
web.job.appl.status.x [wfr.status,wfr.urn]
?(JA)JA.WFS[wfrST,wfr]
|
|
| | | | | | | | | | | | | | | | | | | | | | | |